package com.gxa.dao;

import com.gxa.pojo.Department;

import java.sql.SQLException;
import java.util.List;

public interface DepartmentDao {
    //查询所有数据
    List<Department> queryDepartmentList(Integer param01, Integer param02) throws SQLException;

    //查询总记录数
    Integer countDepartment() throws SQLException;

    //添加
    int add(Department department, String date) throws SQLException;

    //删除
    int delDepartment(String id) throws SQLException;

    //修改
    int mod(Department department, String date) throws SQLException;

    //条件查询
    List<Department> searchDepartment(Integer param01, Integer param02, String name) throws SQLException;

    Integer countDepartment(String name) throws SQLException;

}
